A conceptual modelling perspective for data warehouses
نویسندگان
چکیده
The volume of information of the most various types stored electronically in a company is increasing to an ever-greater extent. While in the field of operational systems everything is aimed at achieving the quickest possible throughput, in the dispositive field, questions regarding the total overview or detailed views are of interest. OLAP servers are multidimensionally structured. They are therefore suited for the analysis of multidimensional datastores. The functionality of the OLAP server, such as, creation of forms, drill down, roll up, slice and dice, analysis technology, multidimensional consolidation, etc. demonstrate the advantages of this tool. The analysis of the relevant features of the data warehouse and OLAP is based on both the mainstream literature and on our experience in a two-year project Data Warehouse for Tupperware Inc. The second problem addressed by this paper is the discussion of recent approaches for a proposition some formal definitions of basic constructs used in so called multidimensional modelling which seems to be an important technique for data warehousing and OLAP. It is different from E-R modelling and offers a number of important advantages that the E-R modelling lacks. We show a relationship of E-R modelling to the multidimensional modelling and describe a broad class of multidimensional databases based on so called constellation schemes with explicit hierarchies.
منابع مشابه
Data Warehouse Architecture and Quality: Impact and Open Challenges
The CAiSE 98 paper “Architecture and Quality in Data Warehouses” and its expanded journal version [18] was the first to add a Zachman-like [37] explicit conceptual enterprise modeling perspective to the architecture of data warehouses. Until then, data warehouses were just seen as collections of – typically multidimensional and historized – materialized views on relational tables, without consi...
متن کاملA UML 2.0/OCL Extension for Designing Secure Data Warehouses
At present, it is very difficult to develop a methodology that fulfills all criteria and comprises all security constraints in the successful design of data warehouses. If that methodology were developed, its complexity would hinder its success. The solution, therefore, would be an approach in which techniques and models defined by the most accepted model standards were extended by integrating ...
متن کاملUser-Centric Spatial DataWarehousing: A Survey of Requirements & Approaches
Data warehouses have traditionally been used to analyse large multidimensional datasets and provide enterprise decision support. With an increased availability of spatial data in recent years, several new strategies have been proposed to enable their integration into data warehouses and OLAP systems and perform complex analysis on them. One strategy to achieve this is to integrate existing Geog...
متن کاملPreface to CoMoL 2009
Conceptual modelling has changed over years. Database applications form an integral part of most computational infrastructures. Applications are developed, changed and integrated by specialists in conceptual modelling, by computer engineers, or by people who do not have sufficient related background knowledge. Conceptual databases models are everywhere in applications and are likely to interfer...
متن کاملBuilding Data Warehouses Using the Enterprise Modeling Framework
This paper proposes an enterprise modeling framework for the deployment of data warehouses. The framework provides the information roadmap coordinating source data and different data warehouses across the business enterprise. The paper introduces a solution to address data warehousing issues at the enterprise level while avoiding the pitfalls of creating enterprise data warehouses and universal...
متن کامل